Open topic with navigation

ActivatePartnerByWhere

Declaration

function TFloActionManager.ActivatePartnerByWhere(aWhere: string): boolean;

Example

procedure OnMapEvent(var Value:Variant);

begin

Action.ActivatePartnerByWhere('where partnertype=1 and supplierid=''ABC''')

end;

Description

Finds and activates a Trading Partner based on the filter provided by aWhere parameter. aWhere is a where clause for a SQL query. You can use any fields from the FLO_TRADINGPARTNERS table in the Flow configuration database to build your where clause.

The fields in the FLO_TRADINGPARTNERS table include:

• FID (type guid)
• MODULENAME (type varchar) - corresponds to Partner Name
• PARTNERTYPE (type integer) - corresponds to Partner Type
• CUSTOMERID (type varchar) - corresponds to Your ID for them as customer
• TPSUPPLIERID (type varchar) - corresponds to Their ID for you as supplier
• SUPPLIERID (type varchar) - corresponds to Your ID for them as supplier
• TPCUSTOMERID (type varchar) - corresponds to Their ID for you as customer
• MEMBERID (type varchar) - corresponds to Custom Id
• USERNAME (type varchar) - corresponds to User Name
• USERPASS (type varchar (encrypted)) - corresponds to User Password

Also see Trading Partner Attributes